package com.sc.nft.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sc.nft.entity.MallBanner;
import com.sc.nft.entity.vo.MallBannerVO;
import org.apache.ibatis.annotations.Param;
import com.sc.nft.entity.MallBanner;

import java.util.Date;
import java.util.List;

/**
 * 商城banner表(MallBanner)表数据库访问层
 *
 * @author wwc
 * @since 2023-05-16 10:58:43
 */
public interface MallBannerMapper extends BaseMapper<MallBanner> {

    /**
     * 查询配置定时上下架和没有配置定时上下架的banner
     * @param location
     * @param status
     * @param date
     * @return
     */
    List<MallBannerVO> listByLocationAndStatusAndTime(@Param("location")Long location,@Param("status")Integer status,@Param("date")Date date);

    /**
     * 后台分页查询所有banner
     * @return
     */
    Page<MallBannerVO> pageAdmin(Page page);
}
